Date fields: Date Input / Date Output

Control how EMu formats dates when they are input into date fields and how dates will display when they are output (retrieved from a database):

Specify the format for dates entered into fields that have a Date data type.

Usage

This Registry entry can be assigned to users, groups and system-wide:

Key User Group System
Key 1 User Group System
Key 2 user group Setting
Key 3 Setting Format
Key 4 Format Date Input
Key 5 Date Input  
Value option
User user Setting Format Date Input option
Group group Setting Format Date Input option
System Setting Format Date Input option

where:

option can be:
DMY Day Month Year
MDY Month Day Year
MYD Month Year Day
DYM Day Year Month
YMD Year Month Day
YDM Year Day Month

Examples

This entry is appropriate for users in the United States, where dates are entered into date fields as Month, Day, Year:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Input
Value MDY

This entry is appropriate for users in Australia, where dates are entered into date fields as Day, Month, Year:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Input
Value DMY

Specify the format in which dates will display in a field in a module when retrieved from a database. Only affects fields that have a Date data type.

Usage

This Registry entry can be assigned to users, groups and system-wide:

Key User Group System
Key 1 User Group System
Key 2 user group Setting
Key 3 Setting Format
Key 4 Format Date Output
Key 5 Date Output  
Value format
User user Setting Format Date Output format
Group group Setting Format Date Output format
System Setting Format Date Output format

where:

format

a series of special characters recognised by the System as format characters:

Character

Description

yy

Year - displayed with two digits, e.g. 2002 will display as 02.

yyyy

Year - displayed with four digits, e.g. 2002 will display as 2002; if year is BC it will print with a preceding negative symbol, e.g. 500 BC will display as -500.

Y

Year - displayed with four digits, e.g. 2002 will display as 2002.

M

Month - values range from 1-12.

MM

Month - two digit values range from 01-12.

MMM

Month - the first three letters of the month are displayed, e.g. Jan, Feb, etc.

MMMM

Month - the entire word is displayed, e.g. January, February, etc.

d

Day - values range from 1-31.

dd

Day - two digit values range from 01-31.

ddd

Day - the first three letters of the weekday are displayed, e.g. Mon, Tue, etc.

dddd

Day - the entire day of week is displayed, e.g. Monday, Tuesday, etc.

e

Era - if the date is BC, BC will be displayed. If the date is AD, nothing will be displayed.

E

Era - either BC or AD will be displayed.

Note: The format characters can be combined to create the desired date string, separated by any other character(s).

Examples

This setting will generate a date format applicable to the United States (e.g. 07/15/2006):

Key Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value MM/dd/yyyy

This setting will generate a date format applicable to Australia (e.g. 15-07-2006):

Key Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value dd-MM-yyyy

This setting will generate a custom date format: Feb 2, 84:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value MMM d, yy

With this setting, dates will display with a preceding era (AD/BC); BC dates will be shown with a negative symbol, e.g. BC -664:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Format
Key 4 Date Output
Value E dd/MM/yyyy